Basic SQL Queries

SQL is a keyword based language. Each statement in SQL begins with a unique keyword. These keywords are not case-sensitive. Other elements that are part of a SQL Queries are: * names - names of databases elements like table name, column name etc,. * literals - quoted strings, numeric values, datetime values * delimiters - +, -, ( ), >, <, >=, <=, <>, * etc,. With SQL we can query a database and have a result set returned. The basic SQL queries that will be discussed in this module are given below: * select * create * delete * update * insert * alter